Gail Shaw wrote:
> The clustered index is the table. The leaf levels of the cluster are the
> actual data pages and they are stored physically in the order of the
> clustering key.

Oh, OK. I guess that makes sense, once I realize that there *is* no 
"table data" outside the index.

> There's a fairly decent diagram here - :
> http://msdn.microsoft.com/en-us/library/ms177443.aspx

That's a fairly good picture of a B-tree. :-)

> Does thet help at all, or have I just muddied the water more?

It helps. I guess I just wasn't thinking it through. Thanks for 
clarifying that.

-- 
Darren New / San Diego, CA, USA (PST)

Post a reply to this message